using HKB.Common;
using System;
using System.CodeDom.Compiler;
using System.ComponentModel;
using System.ComponentModel.Design;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using System.Diagnostics;
namespace HKB.Data.Dal.S_MyFavouriteTableAdapters
{
	[GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0"), DataObject(true), HelpKeyword("vs.data.TableAdapter"), Designer("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"), DesignerCategory("code"), ToolboxItem(true)]
	public class HLShop_MyFavouriteTableAdapter : Component
	{
		private SqlDataAdapter _adapter;
		private SqlConnection _connection;
		private SqlCommand[] _commandCollection;
		private bool _clearBeforeFill;
		[System.Diagnostics.DebuggerNonUserCode]
		private SqlDataAdapter Adapter
		{
			get
			{
				if (this._adapter == null)
				{
					this.InitAdapter();
				}
				return this._adapter;
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		internal SqlConnection Connection
		{
			get
			{
				if (this._connection == null)
				{
					this.InitConnection();
				}
				return this._connection;
			}
			set
			{
				this._connection = value;
				if (this.Adapter.InsertCommand != null)
				{
					this.Adapter.InsertCommand.Connection = value;
				}
				if (this.Adapter.DeleteCommand != null)
				{
					this.Adapter.DeleteCommand.Connection = value;
				}
				if (this.Adapter.UpdateCommand != null)
				{
					this.Adapter.UpdateCommand.Connection = value;
				}
				for (int i = 0; i < this.CommandCollection.Length; i++)
				{
					if (this.CommandCollection[i] != null)
					{
						this.CommandCollection[i].Connection = value;
					}
				}
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		protected SqlCommand[] CommandCollection
		{
			get
			{
				if (this._commandCollection == null)
				{
					this.InitCommandCollection();
				}
				return this._commandCollection;
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		public bool ClearBeforeFill
		{
			get
			{
				return this._clearBeforeFill;
			}
			set
			{
				this._clearBeforeFill = value;
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		public HLShop_MyFavouriteTableAdapter()
		{
			this.ClearBeforeFill = true;
		}
		[System.Diagnostics.DebuggerNonUserCode]
		private void InitAdapter()
		{
			this._adapter = new SqlDataAdapter();
			DataTableMapping dataTableMapping = new DataTableMapping();
			dataTableMapping.SourceTable = "Table";
			dataTableMapping.DataSetTable = "HLShop_MyFavourite";
			dataTableMapping.ColumnMappings.Add("F_ID", "F_ID");
			dataTableMapping.ColumnMappings.Add("F_UserID", "F_UserID");
			dataTableMapping.ColumnMappings.Add("F_ProductID", "F_ProductID");
			dataTableMapping.ColumnMappings.Add("F_ShopID", "F_ShopID");
			dataTableMapping.ColumnMappings.Add("F_Update", "F_Update");
			dataTableMapping.ColumnMappings.Add("F_Type", "F_Type");
			dataTableMapping.ColumnMappings.Add("F_SearchName", "F_SearchName");
			dataTableMapping.ColumnMappings.Add("F_SearchContens", "F_SearchContens");
			dataTableMapping.ColumnMappings.Add("F_Remark", "F_Remark");
			this._adapter.TableMappings.Add(dataTableMapping);
			this._adapter.DeleteCommand = new SqlCommand();
			this._adapter.DeleteCommand.Connection = this.Connection;
			this._adapter.DeleteCommand.CommandText = "DELETE FROM [HLShop_MyFavourite] WHERE (([F_ID] = @Original_F_ID))";
			this._adapter.DeleteCommand.CommandType = CommandType.Text;
			this._adapter.DeleteCommand.Parameters.Add(new SqlParameter("@Original_F_ID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "F_ID", DataRowVersion.Original, false, null, "", "", ""));
			this._adapter.InsertCommand = new SqlCommand();
			this._adapter.InsertCommand.Connection = this.Connection;
			this._adapter.InsertCommand.CommandText = "INSERT INTO [HLShop_MyFavourite] ([F_UserID], [F_ProductID], [F_ShopID], [F_Update], [F_Type], [F_SearchName], [F_SearchContens], [F_Remark]) VALUES (@F_UserID, @F_ProductID, @F_ShopID, @F_Update, @F_Type, @F_SearchName, @F_SearchContens, @F_Remark)";
			this._adapter.InsertCommand.CommandType = CommandType.Text;
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@F_UserID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "F_UserID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@F_ProductID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "F_ProductID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@F_ShopID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "F_ShopID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@F_Update", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "F_Update", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@F_Type", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "F_Type", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@F_SearchName", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "F_SearchName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@F_SearchContens", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "F_SearchContens", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@F_Remark", SqlDbType.Text, 0, ParameterDirection.Input, 0, 0, "F_Remark", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand = new SqlCommand();
			this._adapter.UpdateCommand.Connection = this.Connection;
			this._adapter.UpdateCommand.CommandText = "UPDATE [HLShop_MyFavourite] SET [F_UserID] = @F_UserID, [F_ProductID] = @F_ProductID, [F_ShopID] = @F_ShopID, [F_Update] = @F_Update, [F_Type] = @F_Type, [F_SearchName] = @F_SearchName, [F_SearchContens] = @F_SearchContens, [F_Remark] = @F_Remark WHERE (([F_ID] = @Original_F_ID))";
			this._adapter.UpdateCommand.CommandType = CommandType.Text;
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@F_UserID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "F_UserID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@F_ProductID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "F_ProductID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@F_ShopID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "F_ShopID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@F_Update", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "F_Update", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@F_Type", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "F_Type", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@F_SearchName", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "F_SearchName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@F_SearchContens", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "F_SearchContens", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@F_Remark", SqlDbType.Text, 0, ParameterDirection.Input, 0, 0, "F_Remark", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Original_F_ID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "F_ID", DataRowVersion.Original, false, null, "", "", ""));
		}
		[System.Diagnostics.DebuggerNonUserCode]
		private void InitConnection()
		{
			this._connection = new SqlConnection();
			this._connection.ConnectionString = Conn.CurrenConnectionStrings;
		}
		[System.Diagnostics.DebuggerNonUserCode]
		private void InitCommandCollection()
		{
			this._commandCollection = new SqlCommand[18];
			this._commandCollection[0] = new SqlCommand();
			this._commandCollection[0].Connection = this.Connection;
			this._commandCollection[0].CommandText = "SELECT F_ID, F_UserID, F_ProductID, F_ShopID, F_Update, F_Type, F_SearchName, F_SearchContens, F_Remark FROM HLShop_MyFavourite";
			this._commandCollection[0].CommandType = CommandType.Text;
			this._commandCollection[1] = new SqlCommand();
			this._commandCollection[1].Connection = this.Connection;
			this._commandCollection[1].CommandText = "DELETE   [HLShop_MyFavourite] WHERE  ([F_ID] = @F_ID)  ";
			this._commandCollection[1].CommandType = CommandType.Text;
			this._commandCollection[1].Parameters.Add(new SqlParameter("@F_ID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "F_ID", DataRowVersion.Original, false, null, "", "", ""));
			this._commandCollection[2] = new SqlCommand();
			this._commandCollection[2].Connection = this.Connection;
			this._commandCollection[2].CommandText = "DELETE FROM [HLShop_MyFavourite] WHERE [F_ID]  in  (SELECT * FROM fn_Split(@ArrayF_ID,','))\r\n";
			this._commandCollection[2].CommandType = CommandType.Text;
			this._commandCollection[2].Parameters.Add(new SqlParameter("@ArrayF_ID", SqlDbType.VarChar, 1024, ParameterDirection.Input, 0, 0, "", DataRowVersion.Original, false, null, "", "", ""));
			this._commandCollection[3] = new SqlCommand();
			this._commandCollection[3].Connection = this.Connection;
			this._commandCollection[3].CommandText = "SELECT count(F_ID)   as  allcount\r\nFROM HLShop_MyFavourite where F_UserID=@F_UserID and F_Type=0  ";
			this._commandCollection[3].CommandType = CommandType.Text;
			this._commandCollection[3].Parameters.Add(new SqlParameter("@F_UserID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "F_UserID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[4] = new SqlCommand();
			this._commandCollection[4].Connection = this.Connection;
			this._commandCollection[4].CommandText = "SELECT count(F_ID)   as  allcount\r\nFROM HLShop_MyFavourite where F_UserID=@F_UserID and F_type=1 ";
			this._commandCollection[4].CommandType = CommandType.Text;
			this._commandCollection[4].Parameters.Add(new SqlParameter("@F_UserID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "F_UserID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[5] = new SqlCommand();
			this._commandCollection[5].Connection = this.Connection;
			this._commandCollection[5].CommandText = "SELECT F_ID, F_UserID, F_ProductID, F_ShopID, F_Update, F_Type, F_SearchName, \r\n      F_SearchContens, F_ProductClassID, F_ShopClassID, F_Remark\r\nFROM HLShop_MyFavourite\r\nWHERE (F_ID = @F_ID)";
			this._commandCollection[5].CommandType = CommandType.Text;
			this._commandCollection[5].Parameters.Add(new SqlParameter("@F_ID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "F_ID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[6] = new SqlCommand();
			this._commandCollection[6].Connection = this.Connection;
			this._commandCollection[6].CommandText = "SELECT F_ID, F_UserID, F_ProductID, F_ShopID, F_Update, F_Type, F_SearchName, F_SearchContens, F_Remark   \r\nFROM HLShop_MyFavourite \r\nWHERE  F_UserID=@F_UserID AND  F_ProductID=@F_ProductID ";
			this._commandCollection[6].CommandType = CommandType.Text;
			this._commandCollection[6].Parameters.Add(new SqlParameter("@F_UserID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "F_UserID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[6].Parameters.Add(new SqlParameter("@F_ProductID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "F_ProductID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[7] = new SqlCommand();
			this._commandCollection[7].Connection = this.Connection;
			this._commandCollection[7].CommandText = "PR_GetFavKeyWordsBySearchNameUserID";
			this._commandCollection[7].CommandType = CommandType.StoredProcedure;
			this._commandCollection[7].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[7].Parameters.Add(new SqlParameter("@F_SearchName", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[7].Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8] = new SqlCommand();
			this._commandCollection[8].Connection = this.Connection;
			this._commandCollection[8].CommandText = "\r\n                      SELECT HLShop_MyFavourite.F_ID, HLShop_MyFavourite.F_ProductID,\r\n                      HLShop_MyFavourite.F_Update, HLShop_MyFavourite.F_Type, HLShop_MyFavourite.F_ProductClassID,\r\n                      HLShop_MyFavourite.F_ShopClassID,\r\n                      HLShop_MyFavourite.F_Remark, HL_User.UserName, HL_User.UserID, SalerID,\r\n                      HLShop_Product.EndDate, HLShop_Product.ProductID,\r\n                      HLShop_Product.ProductName, HLShop_Product.ProductType,\r\n                      HLShop_Product.ShopID,\r\n                      CASE WHEN ProductType = '一口价' THEN StandPrice WHEN ProductType = '团购' THEN\r\n                      TeamPrice5 ELSE AuctionStartPrice END AS ProductPrice, DATEDIFF(s, GETDATE(),\r\n                      HLShop_Product.EndDate) AS LeftTime, HLShop_Product.ProductSmallImageUrl,\r\n                      HLShop_MyFavourite.F_UserID\r\n                      FROM HLShop_MyFavourite INNER JOIN\r\n                      HLShop_Product ON\r\n                      HLShop_MyFavourite.F_ProductID = HLShop_Product.ProductID INNER JOIN\r\n                      HL_User ON HLShop_Product.SalerID = HL_User.UserID\r\n                      WHERE (HLShop_MyFavourite.F_Type = 0) AND (HLShop_MyFavourite.F_ID = @F_ID)";
			this._commandCollection[8].CommandType = CommandType.Text;
			this._commandCollection[8].Parameters.Add(new SqlParameter("@F_ID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "F_ID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[9] = new SqlCommand();
			this._commandCollection[9].Connection = this.Connection;
			this._commandCollection[9].CommandText = "PR_GetFavProByUpdtPNamePEdtFPCUserID";
			this._commandCollection[9].CommandType = CommandType.StoredProcedure;
			this._commandCollection[9].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[9].Parameters.Add(new SqlParameter("@F_Update", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[9].Parameters.Add(new SqlParameter("@ProductName", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[9].Parameters.Add(new SqlParameter("@ProductEndDate", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[9].Parameters.Add(new SqlParameter("@F_ProductClassID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[9].Parameters.Add(new SqlParameter("@F_UserID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[10] = new SqlCommand();
			this._commandCollection[10].Connection = this.Connection;
			this._commandCollection[10].CommandText = "\r\n                      SELECT HLShop_MyFavourite.F_ID, HLShop_MyFavourite.F_Remark,\r\n                      HLShop_MyFavourite.F_UserID, HLShop_Shop.ShopID, HLShop_Shop.ShopName,\r\n                      HLShop_Shop.ShopGroupID, HLShop_Shop.ShopCategoryID,\r\n                      HLShop_Class.ClassName, HLShop_Shop.ShopImageUrl, HLShop_Class.ClassID,\r\n                      HL_User.UserID, HL_User.UserName,HLShop_MyFavourite.F_ProductClassID,\r\n                      HLShop_MyFavourite.F_ShopClassID,HL_UserInfo.SaleCrediet\r\n                      FROM HLShop_MyFavourite INNER JOIN\r\n                      HLShop_Shop ON\r\n                      HLShop_MyFavourite.F_ShopID = HLShop_Shop.ShopID INNER JOIN\r\n                      HLShop_Class ON\r\n                      HLShop_Shop.ShopCategoryID = HLShop_Class.ClassID INNER JOIN\r\n                      HL_User ON HLShop_Shop.ShopOwnerID = HL_User.UserID Inner Join\r\n                      HL_UserInfo On HL_UserInfo.UserID=HLShop_Shop.ShopOwnerID\r\n                      WHERE (HLShop_MyFavourite.F_Type = 1) AND (HLShop_MyFavourite.F_ID = @F_ID)";
			this._commandCollection[10].CommandType = CommandType.Text;
			this._commandCollection[10].Parameters.Add(new SqlParameter("@F_ID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "F_ID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[11] = new SqlCommand();
			this._commandCollection[11].Connection = this.Connection;
			this._commandCollection[11].CommandText = "PR_GetFavShopByShopNameShopChildFPCUserID";
			this._commandCollection[11].CommandType = CommandType.StoredProcedure;
			this._commandCollection[11].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[11].Parameters.Add(new SqlParameter("@ShopName", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[11].Parameters.Add(new SqlParameter("@ShopChildid", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[11].Parameters.Add(new SqlParameter("@F_ShopClassID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[11].Parameters.Add(new SqlParameter("@F_UserID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[12] = new SqlCommand();
			this._commandCollection[12].Connection = this.Connection;
			this._commandCollection[12].CommandText = "SELECT COUNT(*) AS allcount\r\nFROM HLShop_MyFavourite\r\nWHERE (F_UserID = @F_USERID) AND (F_ProductClassID = @F_ProductClassID) AND \r\n      (F_Type = 0)";
			this._commandCollection[12].CommandType = CommandType.Text;
			this._commandCollection[12].Parameters.Add(new SqlParameter("@F_USERID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "F_UserID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[12].Parameters.Add(new SqlParameter("@F_ProductClassID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "F_ProductClassID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13] = new SqlCommand();
			this._commandCollection[13].Connection = this.Connection;
			this._commandCollection[13].CommandText = "SELECT  COUNT(*) as  allcount\r\nFROM HLShop_MyFavourite WHERE  F_USERID=@F_USERID AND F_ProductClassID=@F_ProductClassID and F_Type=1  ";
			this._commandCollection[13].CommandType = CommandType.Text;
			this._commandCollection[13].Parameters.Add(new SqlParameter("@F_USERID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "F_UserID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@F_ProductClassID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "F_ProductClassID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14] = new SqlCommand();
			this._commandCollection[14].Connection = this.Connection;
			this._commandCollection[14].CommandText = "PR_InsertMyFavourite";
			this._commandCollection[14].CommandType = CommandType.StoredProcedure;
			this._commandCollection[14].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@F_UserID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@F_ProductID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@F_ShopID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@F_Update", SqlDbType.DateTime, 8, ParameterDirection.Input, 23, 3, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@F_Type", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@F_SearchName", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@F_SearchContens", SqlDbType.VarChar, 500, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@F_ProductClassID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@F_ShopClassID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@F_Remark", SqlDbType.Text, 2147483647, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15] = new SqlCommand();
			this._commandCollection[15].Connection = this.Connection;
			this._commandCollection[15].CommandText = "UPDATE [HLShop_MyFavourite] SET  F_ProductClassID =@F_ProductClassID \r\nwhere F_ID in (SELECT * FROM fn_Split(@ArrayF_ID,','))";
			this._commandCollection[15].CommandType = CommandType.Text;
			this._commandCollection[15].Parameters.Add(new SqlParameter("@F_ProductClassID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "F_ProductClassID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@ArrayF_ID", SqlDbType.VarChar, 1024, ParameterDirection.Input, 0, 0, "", DataRowVersion.Original, false, null, "", "", ""));
			this._commandCollection[16] = new SqlCommand();
			this._commandCollection[16].Connection = this.Connection;
			this._commandCollection[16].CommandText = "UPDATE [HLShop_MyFavourite] SET  F_ShopClassID =@F_ShopClassID \r\nwhere F_ID in (SELECT * FROM fn_Split(@ArrayF_ID,','))";
			this._commandCollection[16].CommandType = CommandType.Text;
			this._commandCollection[16].Parameters.Add(new SqlParameter("@F_ShopClassID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "F_ShopClassID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[16].Parameters.Add(new SqlParameter("@ArrayF_ID", SqlDbType.VarChar, 1024, ParameterDirection.Input, 0, 0, "", DataRowVersion.Original, false, null, "", "", ""));
			this._commandCollection[17] = new SqlCommand();
			this._commandCollection[17].Connection = this.Connection;
			this._commandCollection[17].CommandText = "UPDATE [HLShop_MyFavourite] SET  [F_ProductID] = @F_ProductID, [F_ShopID] = @F_ShopID, [F_Update] = @F_Update, [F_Type] = @F_Type, [F_SearchName] = @F_SearchName, [F_SearchContens] = @F_SearchContens, [F_ProductClassID] = @F_ProductClassID, [F_ShopClassID] = @F_ShopClassID,F_Remark=@F_Remark WHERE (([F_ID] = @F_ID))";
			this._commandCollection[17].CommandType = CommandType.Text;
			this._commandCollection[17].Parameters.Add(new SqlParameter("@F_ProductID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "F_ProductID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[17].Parameters.Add(new SqlParameter("@F_ShopID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "F_ShopID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[17].Parameters.Add(new SqlParameter("@F_Update", SqlDbType.DateTime, 8, ParameterDirection.Input, 0, 0, "F_Update", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[17].Parameters.Add(new SqlParameter("@F_Type", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "F_Type", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[17].Parameters.Add(new SqlParameter("@F_SearchName", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, "F_SearchName", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[17].Parameters.Add(new SqlParameter("@F_SearchContens", SqlDbType.VarChar, 800, ParameterDirection.Input, 0, 0, "F_SearchContens", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[17].Parameters.Add(new SqlParameter("@F_ProductClassID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "F_ProductClassID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[17].Parameters.Add(new SqlParameter("@F_ShopClassID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "F_ShopClassID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[17].Parameters.Add(new SqlParameter("@F_Remark", SqlDbType.Text, 2147483647, ParameterDirection.Input, 0, 0, "F_Remark", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[17].Parameters.Add(new SqlParameter("@F_ID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "F_ID", DataRowVersion.Original, false, null, "", "", ""));
		}
		[DataObjectMethod(DataObjectMethodType.Select, true), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_MyFavourite.HLShop_MyFavouriteDataTable GetAllFav()
		{
			this.Adapter.SelectCommand = this.CommandCollection[0];
			S_MyFavourite.HLShop_MyFavouriteDataTable hLShop_MyFavouriteDataTable = new S_MyFavourite.HLShop_MyFavouriteDataTable();
			this.Adapter.Fill(hLShop_MyFavouriteDataTable);
			return hLShop_MyFavouriteDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_MyFavourite.HLShop_MyFavouriteDataTable GetAllProductCount(int? F_UserID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[3];
			if (F_UserID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = F_UserID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			S_MyFavourite.HLShop_MyFavouriteDataTable hLShop_MyFavouriteDataTable = new S_MyFavourite.HLShop_MyFavouriteDataTable();
			this.Adapter.Fill(hLShop_MyFavouriteDataTable);
			return hLShop_MyFavouriteDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_MyFavourite.HLShop_MyFavouriteDataTable GetAllShopCount(int? F_UserID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[4];
			if (F_UserID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = F_UserID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			S_MyFavourite.HLShop_MyFavouriteDataTable hLShop_MyFavouriteDataTable = new S_MyFavourite.HLShop_MyFavouriteDataTable();
			this.Adapter.Fill(hLShop_MyFavouriteDataTable);
			return hLShop_MyFavouriteDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_MyFavourite.HLShop_MyFavouriteDataTable GetFAVByID(int F_ID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[5];
			this.Adapter.SelectCommand.Parameters[0].Value = F_ID;
			S_MyFavourite.HLShop_MyFavouriteDataTable hLShop_MyFavouriteDataTable = new S_MyFavourite.HLShop_MyFavouriteDataTable();
			this.Adapter.Fill(hLShop_MyFavouriteDataTable);
			return hLShop_MyFavouriteDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_MyFavourite.HLShop_MyFavouriteDataTable GetFavByUserIDProductID(int? F_UserID, int? F_ProductID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[6];
			if (F_UserID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = F_UserID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (F_ProductID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = F_ProductID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			S_MyFavourite.HLShop_MyFavouriteDataTable hLShop_MyFavouriteDataTable = new S_MyFavourite.HLShop_MyFavouriteDataTable();
			this.Adapter.Fill(hLShop_MyFavouriteDataTable);
			return hLShop_MyFavouriteDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_MyFavourite.HLShop_MyFavouriteDataTable GetFavKeyWordsBySearchNameUserID(string F_SearchName, int? UserID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[7];
			if (F_SearchName == null)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = F_SearchName;
			}
			if (UserID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = UserID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			S_MyFavourite.HLShop_MyFavouriteDataTable hLShop_MyFavouriteDataTable = new S_MyFavourite.HLShop_MyFavouriteDataTable();
			this.Adapter.Fill(hLShop_MyFavouriteDataTable);
			return hLShop_MyFavouriteDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_MyFavourite.HLShop_MyFavouriteDataTable GetFavProByF_ID(int F_ID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[8];
			this.Adapter.SelectCommand.Parameters[0].Value = F_ID;
			S_MyFavourite.HLShop_MyFavouriteDataTable hLShop_MyFavouriteDataTable = new S_MyFavourite.HLShop_MyFavouriteDataTable();
			this.Adapter.Fill(hLShop_MyFavouriteDataTable);
			return hLShop_MyFavouriteDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_MyFavourite.HLShop_MyFavouriteDataTable GetFavProByUpdtPNamePEdtFPCUserID(int? F_Update, string ProductName, int? ProductEndDate, int? F_ProductClassID, int? F_UserID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[9];
			if (F_Update.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = F_Update.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (ProductName == null)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = ProductName;
			}
			if (ProductEndDate.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = ProductEndDate.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			if (F_ProductClassID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[4].Value = F_ProductClassID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[4].Value = System.DBNull.Value;
			}
			if (F_UserID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[5].Value = F_UserID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[5].Value = System.DBNull.Value;
			}
			S_MyFavourite.HLShop_MyFavouriteDataTable hLShop_MyFavouriteDataTable = new S_MyFavourite.HLShop_MyFavouriteDataTable();
			this.Adapter.Fill(hLShop_MyFavouriteDataTable);
			return hLShop_MyFavouriteDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_MyFavourite.HLShop_MyFavouriteDataTable GetFavShopByF_ID(int F_ID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[10];
			this.Adapter.SelectCommand.Parameters[0].Value = F_ID;
			S_MyFavourite.HLShop_MyFavouriteDataTable hLShop_MyFavouriteDataTable = new S_MyFavourite.HLShop_MyFavouriteDataTable();
			this.Adapter.Fill(hLShop_MyFavouriteDataTable);
			return hLShop_MyFavouriteDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_MyFavourite.HLShop_MyFavouriteDataTable GetFavShopByShopNameShopChildFPCUserID(string ShopName, int? ShopChildid, int? F_ShopClassID, int? F_UserID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[11];
			if (ShopName == null)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = ShopName;
			}
			if (ShopChildid.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = ShopChildid.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			if (F_ShopClassID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = F_ShopClassID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			if (F_UserID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[4].Value = F_UserID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[4].Value = System.DBNull.Value;
			}
			S_MyFavourite.HLShop_MyFavouriteDataTable hLShop_MyFavouriteDataTable = new S_MyFavourite.HLShop_MyFavouriteDataTable();
			this.Adapter.Fill(hLShop_MyFavouriteDataTable);
			return hLShop_MyFavouriteDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_MyFavourite.HLShop_MyFavouriteDataTable GetProductCountByClassID(int? F_USERID, int? F_ProductClassID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[12];
			if (F_USERID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = F_USERID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (F_ProductClassID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = F_ProductClassID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			S_MyFavourite.HLShop_MyFavouriteDataTable hLShop_MyFavouriteDataTable = new S_MyFavourite.HLShop_MyFavouriteDataTable();
			this.Adapter.Fill(hLShop_MyFavouriteDataTable);
			return hLShop_MyFavouriteDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_MyFavourite.HLShop_MyFavouriteDataTable GetShopCountByClassID(int? F_USERID, int? F_ProductClassID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[13];
			if (F_USERID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = F_USERID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (F_ProductClassID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = F_ProductClassID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			S_MyFavourite.HLShop_MyFavouriteDataTable hLShop_MyFavouriteDataTable = new S_MyFavourite.HLShop_MyFavouriteDataTable();
			this.Adapter.Fill(hLShop_MyFavouriteDataTable);
			return hLShop_MyFavouriteDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_MyFavourite.HLShop_MyFavouriteDataTable InsertFav(int? F_UserID, int? F_ProductID, int? F_ShopID, System.DateTime? F_Update, int? F_Type, string F_SearchName, string F_SearchContens, int? F_ProductClassID, int? F_ShopClassID, string F_Remark)
		{
			this.Adapter.SelectCommand = this.CommandCollection[14];
			if (F_UserID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = F_UserID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (F_ProductID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = F_ProductID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			if (F_ShopID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = F_ShopID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			if (F_Update.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[4].Value = F_Update.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[4].Value = System.DBNull.Value;
			}
			if (F_Type.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[5].Value = F_Type.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[5].Value = System.DBNull.Value;
			}
			if (F_SearchName == null)
			{
				this.Adapter.SelectCommand.Parameters[6].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[6].Value = F_SearchName;
			}
			if (F_SearchContens == null)
			{
				this.Adapter.SelectCommand.Parameters[7].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[7].Value = F_SearchContens;
			}
			if (F_ProductClassID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[8].Value = F_ProductClassID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[8].Value = System.DBNull.Value;
			}
			if (F_ShopClassID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[9].Value = F_ShopClassID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[9].Value = System.DBNull.Value;
			}
			if (F_Remark == null)
			{
				this.Adapter.SelectCommand.Parameters[10].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[10].Value = F_Remark;
			}
			S_MyFavourite.HLShop_MyFavouriteDataTable hLShop_MyFavouriteDataTable = new S_MyFavourite.HLShop_MyFavouriteDataTable();
			this.Adapter.Fill(hLShop_MyFavouriteDataTable);
			return hLShop_MyFavouriteDataTable;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(S_MyFavourite.HLShop_MyFavouriteDataTable dataTable)
		{
			return this.Adapter.Update(dataTable);
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(S_MyFavourite dataSet)
		{
			return this.Adapter.Update(dataSet, "HLShop_MyFavourite");
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(DataRow dataRow)
		{
			return this.Adapter.Update(new DataRow[]
			{
				dataRow
			});
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(DataRow[] dataRows)
		{
			return this.Adapter.Update(dataRows);
		}
		[DataObjectMethod(DataObjectMethodType.Delete, true), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Delete(int Original_F_ID)
		{
			this.Adapter.DeleteCommand.Parameters[0].Value = Original_F_ID;
			ConnectionState state = this.Adapter.DeleteCommand.Connection.State;
			if ((this.Adapter.DeleteCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				this.Adapter.DeleteCommand.Connection.Open();
			}
			int result;
			try
			{
				int num = this.Adapter.DeleteCommand.ExecuteNonQuery();
				result = num;
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					this.Adapter.DeleteCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Insert, true), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Insert(int? F_UserID, int? F_ProductID, int? F_ShopID, System.DateTime? F_Update, int? F_Type, string F_SearchName, string F_SearchContens, string F_Remark)
		{
			if (F_UserID.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[0].Value = F_UserID.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (F_ProductID.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[1].Value = F_ProductID.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (F_ShopID.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[2].Value = F_ShopID.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[2].Value = System.DBNull.Value;
			}
			if (F_Update.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[3].Value = F_Update.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[3].Value = System.DBNull.Value;
			}
			if (F_Type.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[4].Value = F_Type.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[4].Value = System.DBNull.Value;
			}
			if (F_SearchName == null)
			{
				this.Adapter.InsertCommand.Parameters[5].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[5].Value = F_SearchName;
			}
			if (F_SearchContens == null)
			{
				this.Adapter.InsertCommand.Parameters[6].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[6].Value = F_SearchContens;
			}
			if (F_Remark == null)
			{
				throw new System.ArgumentNullException("F_Remark");
			}
			this.Adapter.InsertCommand.Parameters[7].Value = F_Remark;
			ConnectionState state = this.Adapter.InsertCommand.Connection.State;
			if ((this.Adapter.InsertCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				this.Adapter.InsertCommand.Connection.Open();
			}
			int result;
			try
			{
				int num = this.Adapter.InsertCommand.ExecuteNonQuery();
				result = num;
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					this.Adapter.InsertCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Update, true), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(int? F_UserID, int? F_ProductID, int? F_ShopID, System.DateTime? F_Update, int? F_Type, string F_SearchName, string F_SearchContens, string F_Remark, int Original_F_ID)
		{
			if (F_UserID.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[0].Value = F_UserID.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (F_ProductID.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[1].Value = F_ProductID.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (F_ShopID.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[2].Value = F_ShopID.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[2].Value = System.DBNull.Value;
			}
			if (F_Update.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[3].Value = F_Update.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[3].Value = System.DBNull.Value;
			}
			if (F_Type.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[4].Value = F_Type.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[4].Value = System.DBNull.Value;
			}
			if (F_SearchName == null)
			{
				this.Adapter.UpdateCommand.Parameters[5].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[5].Value = F_SearchName;
			}
			if (F_SearchContens == null)
			{
				this.Adapter.UpdateCommand.Parameters[6].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[6].Value = F_SearchContens;
			}
			if (F_Remark == null)
			{
				throw new System.ArgumentNullException("F_Remark");
			}
			this.Adapter.UpdateCommand.Parameters[7].Value = F_Remark;
			this.Adapter.UpdateCommand.Parameters[8].Value = Original_F_ID;
			ConnectionState state = this.Adapter.UpdateCommand.Connection.State;
			if ((this.Adapter.UpdateCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				this.Adapter.UpdateCommand.Connection.Open();
			}
			int result;
			try
			{
				int num = this.Adapter.UpdateCommand.ExecuteNonQuery();
				result = num;
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					this.Adapter.UpdateCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Delete, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int DeleteFav(int F_ID)
		{
			SqlCommand sqlCommand = this.CommandCollection[1];
			sqlCommand.Parameters[0].Value = F_ID;
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Delete, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int DeleteMyFavourite(string ArrayF_ID)
		{
			SqlCommand sqlCommand = this.CommandCollection[2];
			if (ArrayF_ID == null)
			{
				throw new System.ArgumentNullException("ArrayF_ID");
			}
			sqlCommand.Parameters[0].Value = ArrayF_ID;
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Update, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int MoveFProductClass(int? F_ProductClassID, string ArrayF_ID)
		{
			SqlCommand sqlCommand = this.CommandCollection[15];
			if (F_ProductClassID.HasValue)
			{
				sqlCommand.Parameters[0].Value = F_ProductClassID.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (ArrayF_ID == null)
			{
				throw new System.ArgumentNullException("ArrayF_ID");
			}
			sqlCommand.Parameters[1].Value = ArrayF_ID;
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Update, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int MoveFShopClass(int? F_ShopClassID, string ArrayF_ID)
		{
			SqlCommand sqlCommand = this.CommandCollection[16];
			if (F_ShopClassID.HasValue)
			{
				sqlCommand.Parameters[0].Value = F_ShopClassID.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (ArrayF_ID == null)
			{
				throw new System.ArgumentNullException("ArrayF_ID");
			}
			sqlCommand.Parameters[1].Value = ArrayF_ID;
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Update, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int UpdateFva(int? F_ProductID, int? F_ShopID, System.DateTime? F_Update, int? F_Type, string F_SearchName, string F_SearchContens, int? F_ProductClassID, int? F_ShopClassID, string F_Remark, int F_ID)
		{
			SqlCommand sqlCommand = this.CommandCollection[17];
			if (F_ProductID.HasValue)
			{
				sqlCommand.Parameters[0].Value = F_ProductID.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (F_ShopID.HasValue)
			{
				sqlCommand.Parameters[1].Value = F_ShopID.Value;
			}
			else
			{
				sqlCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (F_Update.HasValue)
			{
				sqlCommand.Parameters[2].Value = F_Update.Value;
			}
			else
			{
				sqlCommand.Parameters[2].Value = System.DBNull.Value;
			}
			if (F_Type.HasValue)
			{
				sqlCommand.Parameters[3].Value = F_Type.Value;
			}
			else
			{
				sqlCommand.Parameters[3].Value = System.DBNull.Value;
			}
			if (F_SearchName == null)
			{
				sqlCommand.Parameters[4].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[4].Value = F_SearchName;
			}
			if (F_SearchContens == null)
			{
				sqlCommand.Parameters[5].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[5].Value = F_SearchContens;
			}
			if (F_ProductClassID.HasValue)
			{
				sqlCommand.Parameters[6].Value = F_ProductClassID.Value;
			}
			else
			{
				sqlCommand.Parameters[6].Value = System.DBNull.Value;
			}
			if (F_ShopClassID.HasValue)
			{
				sqlCommand.Parameters[7].Value = F_ShopClassID.Value;
			}
			else
			{
				sqlCommand.Parameters[7].Value = System.DBNull.Value;
			}
			if (F_Remark == null)
			{
				sqlCommand.Parameters[8].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[8].Value = F_Remark;
			}
			sqlCommand.Parameters[9].Value = F_ID;
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
	}
}
